select a.id, a.nama,  a.tgl_lahir,(YEAR(CURDATE())-YEAR(a.tgl_lahir)) AS usia,b.jenis, a.no_kartu from patients a inner join typepatients b on a.typepatient_id=b.id where a.id like "%1%" 
